﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace EffiProzDB
{
    class Test
    {
        

        public static void Main(string[] args)
        {
            SessionInterface sessionProxy;
            String user = "sa";
            String password = "";
            String connType = DatabaseURL.S_MEM;
            //String host = "localhost";
            //int port = 0;
            //String path = "";
            String database = "testdb";
            HsqlProperties props = new HsqlProperties();

            string sql = "CREATE USER irantha PASSWORD catdog123 ADMIN";

            sessionProxy = DatabaseManager.newSession(connType, database,
                      user, password, props);

            Result resultOut = new Result(ResultConstants.SQLEXECDIRECT);

            resultOut.setMainString(sql);
            resultOut.setMaxRows(1000);

            
            Result resultIn = sessionProxy.execute(resultOut);

            Console.WriteLine("Press any key to continue...");
            Console.ReadKey(true);
        }
    }
}
